﻿CREATE TABLE [dbo].[Reservations] (
    [ReservationId]       INT      IDENTITY (1, 1) NOT NULL,
    [DateCreated]         DATETIME NOT NULL,
    [UserId]              INT      NOT NULL,
    [StartDate]           DATETIME NOT NULL,
    [Period]              INT      NOT NULL,
    [ReservationStatusId] INT      NOT NULL,
    CONSTRAINT [PK_Reservations] PRIMARY KEY CLUSTERED ([ReservationId] ASC),
    CONSTRAINT [FK_Reservations_ReservationStatus] FOREIGN KEY ([ReservationStatusId]) REFERENCES [dbo].[ReservationStatus] ([ReservationStatusId]),
    CONSTRAINT [FK_Reservations_User] FOREIGN KEY ([UserId]) REFERENCES [dbo].[User] ([UserId])
);

